HI I am trying to creat a dynamic collections in sccm 2007, I am very confused wehen i writing the query in new collection wizard, i have created queries in sql when past this query in the query design in collection its not working and throwing erros and same will happen for existing collection in sql (if i use the all systems qury in sql ). pleasesuggest me or explain me how i can effectivle create custome collections to meet my requirements Satya

Start with this: Collection are NOT SQL queries. Not at all. They are WQL queries--it looks somewhat similar to SQL; but you absolutely cannot take a SQL query and drop it into a collection query--it will never ever work. What exactly is the SQL query you are trying to make be WQL (collection) query? One of us can help you translate--or one of us can tell you why what you are trying to do is impossible in WQL. ;)Standardize. Simplify. Automate.